Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 494 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 52.2 KiB |
| Average record size in memory | 108.1 B |
Variable types
| NUM | 12 |
|---|---|
| CAT | 3 |
Symbol has constant value "494" | Constant |
Series has constant value "494" | Constant |
Open Price is highly correlated with Prev Close and 5 other fields | High correlation |
Prev Close is highly correlated with Open Price and 5 other fields | High correlation |
High Price is highly correlated with Prev Close and 5 other fields | High correlation |
Low Price is highly correlated with Prev Close and 5 other fields | High correlation |
Last Price is highly correlated with Prev Close and 5 other fields | High correlation |
Close Price is highly correlated with Prev Close and 5 other fields | High correlation |
Average Price is highly correlated with Prev Close and 5 other fields | High correlation |
No. of Trades is highly correlated with Total Traded Quantity and 1 other fields | High correlation |
Total Traded Quantity is highly correlated with No. of Trades | High correlation |
Turnover is highly correlated with No. of Trades | High correlation |
Date has unique values | Unique |
Total Traded Quantity has unique values | Unique |
Turnover has unique values | Unique |
No. of Trades has unique values | Unique |
Deliverable Qty has unique values | Unique |
Reproduction
| Analysis started | 2020-09-12 09:00:42.868110 |
|---|---|
| Analysis finished | 2020-09-12 09:01:45.296644 |
| Duration | 1 minute and 2.43 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 KiB |
| RCOM |
|---|
| Value | Count | Frequency (%) | |
| RCOM | 494 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 KiB |
| EQ |
|---|
| Value | Count | Frequency (%) | |
| EQ | 494 | 100.0% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
| Distinct | 494 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 KiB |
| 01-Aug-2017 | 1 |
|---|---|
| 07-Dec-2018 | 1 |
| 24-May-2017 | 1 |
| 05-Feb-2018 | 1 |
| 05-Jul-2017 | 1 |
| Other values (489) |
| Value | Count | Frequency (%) | |
| 01-Aug-2017 | 1 | 0.2% | |
| 07-Dec-2018 | 1 | 0.2% | |
| 24-May-2017 | 1 | 0.2% | |
| 05-Feb-2018 | 1 | 0.2% | |
| 05-Jul-2017 | 1 | 0.2% | |
| 16-Aug-2017 | 1 | 0.2% | |
| 27-Sep-2018 | 1 | 0.2% | |
| 01-Feb-2019 | 1 | 0.2% | |
| 15-Jun-2018 | 1 | 0.2% | |
| 17-Jan-2018 | 1 | 0.2% | |
| Other values (484) | 484 | 98.0% |
Frequencies of value counts
Unique
| Unique | 494 ? |
|---|---|
| Unique (%) | 100.0% |
Histogram of lengths of the category
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
| Distinct | 314 |
|---|---|
| Distinct (%) | 63.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.8201417 |
|---|---|
| Minimum | 1.85 |
| Maximum | 36.15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 1.85 |
|---|---|
| 5-th percentile | 3.8975 |
| Q1 | 12.9125 |
| median | 15.925 |
| Q3 | 22.2875 |
| 95-th percentile | 29.5025 |
| Maximum | 36.15 |
| Range | 34.3 |
| Interquartile range (IQR) | 9.375 |
Descriptive statistics
| Standard deviation | 7.322269665 |
|---|---|
| Coefficient of variation (CV) | 0.435327466 |
| Kurtosis | -0.2555729794 |
| Mean | 16.8201417 |
| Median Absolute Deviation (MAD) | 4.275 |
| Skewness | 0.0955154412 |
| Sum | 8309.15 |
| Variance | 53.61563304 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 13.35 | 6 | 1.2% | |
| 13.55 | 6 | 1.2% | |
| 15.75 | 6 | 1.2% | |
| 13.85 | 6 | 1.2% | |
| 19.05 | 5 | 1.0% | |
| 13.5 | 5 | 1.0% | |
| 11.65 | 5 | 1.0% | |
| 13.8 | 4 | 0.8% | |
| 23.8 | 4 | 0.8% | |
| 14.1 | 4 | 0.8% | |
| Other values (304) | 443 | 89.7% |
| Value | Count | Frequency (%) | |
| 1.85 | 1 | 0.2% | |
| 1.9 | 2 | 0.4% | |
| 1.95 | 1 | 0.2% | |
| 2 | 2 | 0.4% | |
| 2.1 | 2 | 0.4% |
| Value | Count | Frequency (%) | |
| 36.15 | 1 | 0.2% | |
| 35.35 | 1 | 0.2% | |
| 34 | 1 | 0.2% | |
| 33.9 | 1 | 0.2% | |
| 33.3 | 1 | 0.2% |
| Distinct | 309 |
|---|---|
| Distinct (%) | 62.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.86325911 |
|---|---|
| Minimum | 1.85 |
| Maximum | 37.25 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 1.85 |
|---|---|
| 5-th percentile | 3.78 |
| Q1 | 12.9125 |
| median | 16 |
| Q3 | 22.3375 |
| 95-th percentile | 29.5375 |
| Maximum | 37.25 |
| Range | 35.4 |
| Interquartile range (IQR) | 9.425 |
Descriptive statistics
| Standard deviation | 7.368338006 |
|---|---|
| Coefficient of variation (CV) | 0.4369462604 |
| Kurtosis | -0.2194136014 |
| Mean | 16.86325911 |
| Median Absolute Deviation (MAD) | 4.3 |
| Skewness | 0.1057878562 |
| Sum | 8330.45 |
| Variance | 54.29240498 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 13.7 | 9 | 1.8% | |
| 13.4 | 6 | 1.2% | |
| 13.3 | 6 | 1.2% | |
| 13.8 | 5 | 1.0% | |
| 13.95 | 5 | 1.0% | |
| 13.6 | 5 | 1.0% | |
| 25 | 4 | 0.8% | |
| 12 | 4 | 0.8% | |
| 13.9 | 4 | 0.8% | |
| 13.5 | 4 | 0.8% | |
| Other values (299) | 442 | 89.5% |
| Value | Count | Frequency (%) | |
| 1.85 | 1 | 0.2% | |
| 1.9 | 2 | 0.4% | |
| 1.95 | 1 | 0.2% | |
| 2 | 3 | 0.6% | |
| 2.1 | 2 | 0.4% |
| Value | Count | Frequency (%) | |
| 37.25 | 1 | 0.2% | |
| 35.25 | 1 | 0.2% | |
| 34.6 | 1 | 0.2% | |
| 34.35 | 1 | 0.2% | |
| 33.95 | 1 | 0.2% |
| Distinct | 305 |
|---|---|
| Distinct (%) | 61.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.44301619 |
|---|---|
| Minimum | 1.85 |
| Maximum | 40.15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 1.85 |
|---|---|
| 5-th percentile | 3.83 |
| Q1 | 13.3625 |
| median | 16.575 |
| Q3 | 22.9 |
| 95-th percentile | 30.8525 |
| Maximum | 40.15 |
| Range | 38.3 |
| Interquartile range (IQR) | 9.5375 |
Descriptive statistics
| Standard deviation | 7.612551476 |
|---|---|
| Coefficient of variation (CV) | 0.436424033 |
| Kurtosis | -0.1577560441 |
| Mean | 17.44301619 |
| Median Absolute Deviation (MAD) | 4.475 |
| Skewness | 0.1090430051 |
| Sum | 8616.85 |
| Variance | 57.95093997 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 12.1 | 8 | 1.6% | |
| 17 | 6 | 1.2% | |
| 13.5 | 5 | 1.0% | |
| 23.5 | 5 | 1.0% | |
| 13.95 | 5 | 1.0% | |
| 13.7 | 5 | 1.0% | |
| 14.2 | 5 | 1.0% | |
| 16.1 | 4 | 0.8% | |
| 13.9 | 4 | 0.8% | |
| 16.3 | 4 | 0.8% | |
| Other values (295) | 443 | 89.7% |
| Value | Count | Frequency (%) | |
| 1.85 | 1 | 0.2% | |
| 1.9 | 1 | 0.2% | |
| 1.95 | 1 | 0.2% | |
| 2 | 2 | 0.4% | |
| 2.05 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 40.15 | 1 | 0.2% | |
| 37.45 | 1 | 0.2% | |
| 36.15 | 1 | 0.2% | |
| 35.45 | 1 | 0.2% | |
| 34.9 | 1 | 0.2% |
| Distinct | 292 |
|---|---|
| Distinct (%) | 59.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.2257085 |
|---|---|
| Minimum | 1.85 |
| Maximum | 33.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 1.85 |
|---|---|
| 5-th percentile | 3.7475 |
| Q1 | 12.3125 |
| median | 15.45 |
| Q3 | 21.65 |
| 95-th percentile | 28.2025 |
| Maximum | 33.95 |
| Range | 32.1 |
| Interquartile range (IQR) | 9.3375 |
Descriptive statistics
| Standard deviation | 7.105001881 |
|---|---|
| Coefficient of variation (CV) | 0.4378854631 |
| Kurtosis | -0.2873532686 |
| Mean | 16.2257085 |
| Median Absolute Deviation (MAD) | 4.2 |
| Skewness | 0.08697925847 |
| Sum | 8015.5 |
| Variance | 50.48105173 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 13.65 | 8 | 1.6% | |
| 13.75 | 7 | 1.4% | |
| 13.35 | 6 | 1.2% | |
| 16.75 | 6 | 1.2% | |
| 13.45 | 6 | 1.2% | |
| 22.65 | 5 | 1.0% | |
| 22 | 5 | 1.0% | |
| 22.1 | 4 | 0.8% | |
| 11.5 | 4 | 0.8% | |
| 11.65 | 4 | 0.8% | |
| Other values (282) | 439 | 88.9% |
| Value | Count | Frequency (%) | |
| 1.85 | 1 | 0.2% | |
| 1.9 | 2 | 0.4% | |
| 1.95 | 1 | 0.2% | |
| 2 | 3 | 0.6% | |
| 2.1 | 2 | 0.4% |
| Value | Count | Frequency (%) | |
| 33.95 | 1 | 0.2% | |
| 33.6 | 1 | 0.2% | |
| 33.35 | 1 | 0.2% | |
| 33.05 | 1 | 0.2% | |
| 32.7 | 1 | 0.2% |
| Distinct | 308 |
|---|---|
| Distinct (%) | 62.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.77732794 |
|---|---|
| Minimum | 1.85 |
| Maximum | 36.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 1.85 |
|---|---|
| 5-th percentile | 3.7475 |
| Q1 | 12.9125 |
| median | 15.85 |
| Q3 | 22.3375 |
| 95-th percentile | 29.2025 |
| Maximum | 36.3 |
| Range | 34.45 |
| Interquartile range (IQR) | 9.425 |
Descriptive statistics
| Standard deviation | 7.312128505 |
|---|---|
| Coefficient of variation (CV) | 0.4358339143 |
| Kurtosis | -0.2498493279 |
| Mean | 16.77732794 |
| Median Absolute Deviation (MAD) | 4.275 |
| Skewness | 0.08170976461 |
| Sum | 8288 |
| Variance | 53.46722327 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 13.9 | 8 | 1.6% | |
| 13.55 | 6 | 1.2% | |
| 13.6 | 5 | 1.0% | |
| 13.65 | 5 | 1.0% | |
| 23 | 5 | 1.0% | |
| 15.85 | 5 | 1.0% | |
| 11.6 | 5 | 1.0% | |
| 14.4 | 5 | 1.0% | |
| 13.95 | 4 | 0.8% | |
| 16.85 | 4 | 0.8% | |
| Other values (298) | 442 | 89.5% |
| Value | Count | Frequency (%) | |
| 1.85 | 1 | 0.2% | |
| 1.9 | 2 | 0.4% | |
| 1.95 | 1 | 0.2% | |
| 2 | 2 | 0.4% | |
| 2.1 | 2 | 0.4% |
| Value | Count | Frequency (%) | |
| 36.3 | 1 | 0.2% | |
| 35.1 | 1 | 0.2% | |
| 33.95 | 1 | 0.2% | |
| 33.9 | 1 | 0.2% | |
| 33.85 | 1 | 0.2% |
| Distinct | 313 |
|---|---|
| Distinct (%) | 63.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.75910931 |
|---|---|
| Minimum | 1.85 |
| Maximum | 36.15 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 1.85 |
|---|---|
| 5-th percentile | 3.7475 |
| Q1 | 12.8625 |
| median | 15.9 |
| Q3 | 22.2375 |
| 95-th percentile | 29.45 |
| Maximum | 36.15 |
| Range | 34.3 |
| Interquartile range (IQR) | 9.375 |
Descriptive statistics
| Standard deviation | 7.317378936 |
|---|---|
| Coefficient of variation (CV) | 0.4366209922 |
| Kurtosis | -0.2566461148 |
| Mean | 16.75910931 |
| Median Absolute Deviation (MAD) | 4.25 |
| Skewness | 0.08507045313 |
| Sum | 8279 |
| Variance | 53.5440345 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 13.55 | 6 | 1.2% | |
| 15.75 | 6 | 1.2% | |
| 13.85 | 6 | 1.2% | |
| 13.35 | 6 | 1.2% | |
| 19.05 | 5 | 1.0% | |
| 13.5 | 5 | 1.0% | |
| 11.65 | 5 | 1.0% | |
| 13.7 | 4 | 0.8% | |
| 14.1 | 4 | 0.8% | |
| 15.65 | 4 | 0.8% | |
| Other values (303) | 443 | 89.7% |
| Value | Count | Frequency (%) | |
| 1.85 | 1 | 0.2% | |
| 1.9 | 2 | 0.4% | |
| 1.95 | 1 | 0.2% | |
| 2 | 2 | 0.4% | |
| 2.1 | 2 | 0.4% |
| Value | Count | Frequency (%) | |
| 36.15 | 1 | 0.2% | |
| 35.35 | 1 | 0.2% | |
| 34 | 1 | 0.2% | |
| 33.9 | 1 | 0.2% | |
| 33.3 | 1 | 0.2% |
| Distinct | 448 |
|---|---|
| Distinct (%) | 90.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.8215587 |
|---|---|
| Minimum | 1.85 |
| Maximum | 36.58 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 1.85 |
|---|---|
| 5-th percentile | 3.767 |
| Q1 | 12.87 |
| median | 15.91 |
| Q3 | 22.4125 |
| 95-th percentile | 29.657 |
| Maximum | 36.58 |
| Range | 34.73 |
| Interquartile range (IQR) | 9.5425 |
Descriptive statistics
| Standard deviation | 7.355213561 |
|---|---|
| Coefficient of variation (CV) | 0.4372492282 |
| Kurtosis | -0.2427677812 |
| Mean | 16.8215587 |
| Median Absolute Deviation (MAD) | 4.255 |
| Skewness | 0.09294748374 |
| Sum | 8309.85 |
| Variance | 54.09916653 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 12.87 | 3 | 0.6% | |
| 2.4 | 3 | 0.6% | |
| 13.83 | 3 | 0.6% | |
| 14.13 | 2 | 0.4% | |
| 13.84 | 2 | 0.4% | |
| 28.82 | 2 | 0.4% | |
| 13.71 | 2 | 0.4% | |
| 22.52 | 2 | 0.4% | |
| 21.29 | 2 | 0.4% | |
| 5.32 | 2 | 0.4% | |
| Other values (438) | 471 | 95.3% |
| Value | Count | Frequency (%) | |
| 1.85 | 1 | 0.2% | |
| 1.9 | 1 | 0.2% | |
| 1.92 | 1 | 0.2% | |
| 1.95 | 1 | 0.2% | |
| 2 | 2 | 0.4% |
| Value | Count | Frequency (%) | |
| 36.58 | 1 | 0.2% | |
| 35.68 | 1 | 0.2% | |
| 34.87 | 1 | 0.2% | |
| 34.01 | 1 | 0.2% | |
| 33.34 | 1 | 0.2% |
| Distinct | 494 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 81814773.31 |
|---|---|
| Minimum | 2367025 |
| Maximum | 827714011 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 2367025 |
|---|---|
| 5-th percentile | 8931096.25 |
| Q1 | 32475402 |
| median | 56953703 |
| Q3 | 93166704.5 |
| 95-th percentile | 247548615.7 |
| Maximum | 827714011 |
| Range | 825346986 |
| Interquartile range (IQR) | 60691302.5 |
Descriptive statistics
| Standard deviation | 96977318.89 |
|---|---|
| Coefficient of variation (CV) | 1.185327722 |
| Kurtosis | 22.3314008 |
| Mean | 81814773.31 |
| Median Absolute Deviation (MAD) | 29261214.5 |
| Skewness | 4.053221929 |
| Sum | 4.041649801e+10 |
| Variance | 9.404600378e+15 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 201135102 | 1 | 0.2% | |
| 100285154 | 1 | 0.2% | |
| 92640562 | 1 | 0.2% | |
| 55758132 | 1 | 0.2% | |
| 24864059 | 1 | 0.2% | |
| 17838396 | 1 | 0.2% | |
| 264930325 | 1 | 0.2% | |
| 19041611 | 1 | 0.2% | |
| 15522124 | 1 | 0.2% | |
| 45185360 | 1 | 0.2% | |
| Other values (484) | 484 | 98.0% |
| Value | Count | Frequency (%) | |
| 2367025 | 1 | 0.2% | |
| 2377164 | 1 | 0.2% | |
| 2617494 | 1 | 0.2% | |
| 3027180 | 1 | 0.2% | |
| 3584592 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 827714011 | 1 | 0.2% | |
| 781836478 | 1 | 0.2% | |
| 774653485 | 1 | 0.2% | |
| 685286689 | 1 | 0.2% | |
| 556849068 | 1 | 0.2% |
| Distinct | 494 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1489669927 |
|---|---|
| Minimum | 4734050 |
| Maximum | 2.506661893e+10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 4734050 |
|---|---|
| 5-th percentile | 99812740.12 |
| Q1 | 465384016.9 |
| median | 800408584.7 |
| Q3 | 1597793883 |
| 95-th percentile | 4326567372 |
| Maximum | 2.506661893e+10 |
| Range | 2.506188488e+10 |
| Interquartile range (IQR) | 1132409866 |
Descriptive statistics
| Standard deviation | 2484907442 |
|---|---|
| Coefficient of variation (CV) | 1.66809264 |
| Kurtosis | 44.63801603 |
| Mean | 1489669927 |
| Median Absolute Deviation (MAD) | 433619202.1 |
| Skewness | 5.874509422 |
| Sum | 7.358969441e+11 |
| Variance | 6.174764993e+18 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 300626870.4 | 1 | 0.2% | |
| 797126244 | 1 | 0.2% | |
| 1228306957 | 1 | 0.2% | |
| 352217019.1 | 1 | 0.2% | |
| 927354937.4 | 1 | 0.2% | |
| 666200143.8 | 1 | 0.2% | |
| 98872774.5 | 1 | 0.2% | |
| 1353485138 | 1 | 0.2% | |
| 381476210.7 | 1 | 0.2% | |
| 1582132377 | 1 | 0.2% | |
| Other values (484) | 484 | 98.0% |
| Value | Count | Frequency (%) | |
| 4734050 | 1 | 0.2% | |
| 4992044.4 | 1 | 0.2% | |
| 5104113.3 | 1 | 0.2% | |
| 6659796 | 1 | 0.2% | |
| 8603020.8 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 2.506661893e+10 | 1 | 0.2% | |
| 2.503625078e+10 | 1 | 0.2% | |
| 2.146104751e+10 | 1 | 0.2% | |
| 1.475117543e+10 | 1 | 0.2% | |
| 1.423465799e+10 | 1 | 0.2% |
| Distinct | 494 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56062.12146 |
|---|---|
| Minimum | 1408 |
| Maximum | 648577 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 1408 |
|---|---|
| 5-th percentile | 7206.65 |
| Q1 | 21688 |
| median | 38198 |
| Q3 | 61075.5 |
| 95-th percentile | 145938.65 |
| Maximum | 648577 |
| Range | 647169 |
| Interquartile range (IQR) | 39387.5 |
Descriptive statistics
| Standard deviation | 71264.93347 |
|---|---|
| Coefficient of variation (CV) | 1.271177965 |
| Kurtosis | 31.96400336 |
| Mean | 56062.12146 |
| Median Absolute Deviation (MAD) | 18386.5 |
| Skewness | 4.885417847 |
| Sum | 27694688 |
| Variance | 5078690743 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 33790 | 1 | 0.2% | |
| 22858 | 1 | 0.2% | |
| 50510 | 1 | 0.2% | |
| 39249 | 1 | 0.2% | |
| 19796 | 1 | 0.2% | |
| 58709 | 1 | 0.2% | |
| 3418 | 1 | 0.2% | |
| 14346 | 1 | 0.2% | |
| 3933 | 1 | 0.2% | |
| 34145 | 1 | 0.2% | |
| Other values (484) | 484 | 98.0% |
| Value | Count | Frequency (%) | |
| 1408 | 1 | 0.2% | |
| 1527 | 1 | 0.2% | |
| 1560 | 1 | 0.2% | |
| 2385 | 1 | 0.2% | |
| 2791 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 648577 | 1 | 0.2% | |
| 639231 | 1 | 0.2% | |
| 591969 | 1 | 0.2% | |
| 586307 | 1 | 0.2% | |
| 349227 | 1 | 0.2% |
| Distinct | 494 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11703466.1 |
|---|---|
| Minimum | 1166757 |
| Maximum | 81671630 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 1166757 |
|---|---|
| 5-th percentile | 2611888.85 |
| Q1 | 5204915 |
| median | 8018975.5 |
| Q3 | 12782847 |
| 95-th percentile | 33890206.4 |
| Maximum | 81671630 |
| Range | 80504873 |
| Interquartile range (IQR) | 7577932 |
Descriptive statistics
| Standard deviation | 11563782.37 |
|---|---|
| Coefficient of variation (CV) | 0.9880647556 |
| Kurtosis | 10.97018548 |
| Mean | 11703466.1 |
| Median Absolute Deviation (MAD) | 3349606 |
| Skewness | 2.96949147 |
| Sum | 5781512251 |
| Variance | 1.337210626e+14 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 8168858 | 1 | 0.2% | |
| 5200220 | 1 | 0.2% | |
| 6579552 | 1 | 0.2% | |
| 6929762 | 1 | 0.2% | |
| 6779235 | 1 | 0.2% | |
| 7021726 | 1 | 0.2% | |
| 9121298 | 1 | 0.2% | |
| 6313320 | 1 | 0.2% | |
| 26867050 | 1 | 0.2% | |
| 13786476 | 1 | 0.2% | |
| Other values (484) | 484 | 98.0% |
| Value | Count | Frequency (%) | |
| 1166757 | 1 | 0.2% | |
| 1220396 | 1 | 0.2% | |
| 1376836 | 1 | 0.2% | |
| 1399815 | 1 | 0.2% | |
| 1442437 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 81671630 | 1 | 0.2% | |
| 78830388 | 1 | 0.2% | |
| 70135068 | 1 | 0.2% | |
| 70128853 | 1 | 0.2% | |
| 69305961 | 1 | 0.2% |
% Dly Qt to Traded Qty
Real number (ℝ≥0)
| Distinct | 443 |
|---|---|
| Distinct (%) | 89.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.64740891 |
|---|---|
| Minimum | 5.37 |
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 3.9 KiB |
Quantile statistics
| Minimum | 5.37 |
|---|---|
| 5-th percentile | 8.1095 |
| Q1 | 10.8625 |
| median | 14.075 |
| Q3 | 20.2475 |
| 95-th percentile | 69.926 |
| Maximum | 100 |
| Range | 94.63 |
| Interquartile range (IQR) | 9.385 |
Descriptive statistics
| Standard deviation | 19.82243103 |
|---|---|
| Coefficient of variation (CV) | 0.9600444838 |
| Kurtosis | 8.167241698 |
| Mean | 20.64740891 |
| Median Absolute Deviation (MAD) | 3.945 |
| Skewness | 2.914780478 |
| Sum | 10199.82 |
| Variance | 392.9287718 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 100 | 10 | 2.0% | |
| 12.87 | 3 | 0.6% | |
| 8.58 | 3 | 0.6% | |
| 12.18 | 2 | 0.4% | |
| 11.89 | 2 | 0.4% | |
| 13.35 | 2 | 0.4% | |
| 19.82 | 2 | 0.4% | |
| 10.87 | 2 | 0.4% | |
| 8.97 | 2 | 0.4% | |
| 10.19 | 2 | 0.4% | |
| Other values (433) | 464 | 93.9% |
| Value | Count | Frequency (%) | |
| 5.37 | 1 | 0.2% | |
| 5.66 | 1 | 0.2% | |
| 5.72 | 1 | 0.2% | |
| 5.94 | 1 | 0.2% | |
| 5.95 | 1 | 0.2% |
| Value | Count | Frequency (%) | |
| 100 | 10 | 2.0% | |
| 99.94 | 1 | 0.2% | |
| 99.76 | 1 | 0.2% | |
| 99.64 | 1 | 0.2% | |
| 99.57 | 1 | 0.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Symbol | Series | Date | Prev Close | Open Price | High Price | Low Price | Last Price | Close Price | Average Price | Total Traded Quantity | Turnover | No. of Trades | Deliverable Qty | % Dly Qt to Traded Qty | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | RCOM | EQ | 15-May-2017 | 32.45 | 32.50 | 32.60 | 31.70 | 32.00 | 32.00 | 31.99 | 7126316 | 2.279973e+08 | 11883 | 1908042 | 26.77 |
| 1 | RCOM | EQ | 16-May-2017 | 32.00 | 32.05 | 32.35 | 31.85 | 32.00 | 32.10 | 32.12 | 7274881 | 2.336877e+08 | 9976 | 2211910 | 30.40 |
| 2 | RCOM | EQ | 17-May-2017 | 32.10 | 32.10 | 32.30 | 31.70 | 31.90 | 31.95 | 31.97 | 6245114 | 1.996360e+08 | 8838 | 1399815 | 22.41 |
| 3 | RCOM | EQ | 18-May-2017 | 31.95 | 31.60 | 31.90 | 31.00 | 31.05 | 31.05 | 31.34 | 11189938 | 3.506776e+08 | 17051 | 3629175 | 32.43 |
| 4 | RCOM | EQ | 19-May-2017 | 31.05 | 31.20 | 31.45 | 30.25 | 30.55 | 30.55 | 30.80 | 11898780 | 3.664547e+08 | 18065 | 3309529 | 27.81 |
| 5 | RCOM | EQ | 22-May-2017 | 30.55 | 30.75 | 30.80 | 29.70 | 29.90 | 29.80 | 30.08 | 10150535 | 3.053526e+08 | 19810 | 3463929 | 34.13 |
| 6 | RCOM | EQ | 23-May-2017 | 29.80 | 29.70 | 29.80 | 27.20 | 27.95 | 28.00 | 28.16 | 25930820 | 7.300927e+08 | 42741 | 5472973 | 21.11 |
| 7 | RCOM | EQ | 24-May-2017 | 28.00 | 28.00 | 28.20 | 25.30 | 25.90 | 25.90 | 26.34 | 46243616 | 1.218051e+09 | 60442 | 12211614 | 26.41 |
| 8 | RCOM | EQ | 25-May-2017 | 25.90 | 25.90 | 26.55 | 25.15 | 26.20 | 25.95 | 25.90 | 28257448 | 7.318248e+08 | 35034 | 6872713 | 24.32 |
| 9 | RCOM | EQ | 26-May-2017 | 25.95 | 26.00 | 26.30 | 25.35 | 25.95 | 25.75 | 25.93 | 14024830 | 3.636344e+08 | 20142 | 4643580 | 33.11 |
Last rows
| Symbol | Series | Date | Prev Close | Open Price | High Price | Low Price | Last Price | Close Price | Average Price | Total Traded Quantity | Turnover | No. of Trades | Deliverable Qty | % Dly Qt to Traded Qty | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 484 | RCOM | EQ | 26-Apr-2019 | 2.00 | 1.90 | 2.05 | 1.90 | 1.90 | 1.90 | 1.92 | 66133254 | 1.268149e+08 | 14346 | 34175624 | 51.68 |
| 485 | RCOM | EQ | 30-Apr-2019 | 1.90 | 1.85 | 1.85 | 1.85 | 1.85 | 1.85 | 1.85 | 22861426 | 4.229364e+07 | 4372 | 22336425 | 97.70 |
| 486 | RCOM | EQ | 02-May-2019 | 1.85 | 1.90 | 1.90 | 1.90 | 1.90 | 1.90 | 1.90 | 16688044 | 3.170728e+07 | 3933 | 16182408 | 96.97 |
| 487 | RCOM | EQ | 03-May-2019 | 1.90 | 1.95 | 1.95 | 1.95 | 1.95 | 1.95 | 1.95 | 2617494 | 5.104113e+06 | 1527 | 2617394 | 100.00 |
| 488 | RCOM | EQ | 06-May-2019 | 1.95 | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | 2367025 | 4.734050e+06 | 1408 | 2367025 | 100.00 |
| 489 | RCOM | EQ | 07-May-2019 | 2.00 | 2.00 | 2.10 | 2.00 | 2.10 | 2.10 | 2.06 | 64199212 | 1.325275e+08 | 9103 | 34677474 | 54.02 |
| 490 | RCOM | EQ | 08-May-2019 | 2.10 | 2.10 | 2.20 | 2.10 | 2.20 | 2.20 | 2.18 | 27455636 | 5.972756e+07 | 4208 | 14957834 | 54.48 |
| 491 | RCOM | EQ | 09-May-2019 | 2.20 | 2.30 | 2.30 | 2.30 | 2.30 | 2.30 | 2.30 | 7854126 | 1.806449e+07 | 2385 | 7711773 | 98.19 |
| 492 | RCOM | EQ | 10-May-2019 | 2.30 | 2.40 | 2.40 | 2.40 | 2.40 | 2.40 | 2.40 | 3584592 | 8.603021e+06 | 1560 | 3584592 | 100.00 |
| 493 | RCOM | EQ | 13-May-2019 | 2.40 | 2.45 | 2.50 | 2.30 | 2.30 | 2.30 | 2.40 | 42329516 | 1.014503e+08 | 9541 | 26309575 | 62.15 |